House Pricing Redux

Dataset statistics

Number of variables	21
Number of observations	1460
Missing cells	207
Missing cells (%)	0.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	751.0 KiB
Average record size in memory	526.7 B

Variable types

Categorical	6
Numeric	14
Boolean	1

Alerts

`OverallQual` is highly correlated with `YearBuilt` and 6 other fields	High correlation
`YearBuilt` is highly correlated with `OverallQual` and 5 other fields	High correlation
`TotalBsmtSF` is highly correlated with `1stFlrSF` and 1 other fields	High correlation
`1stFlrSF` is highly correlated with `TotalBsmtSF` and 1 other fields	High correlation
`2ndFlrSF` is highly correlated with `GrLivArea` and 1 other fields	High correlation
`GrLivArea` is highly correlated with `OverallQual` and 5 other fields	High correlation
`FullBath` is highly correlated with `OverallQual` and 6 other fields	High correlation
`TotRmsAbvGrd` is highly correlated with `2ndFlrSF` and 3 other fields	High correlation
`GarageYrBlt` is highly correlated with `OverallQual` and 5 other fields	High correlation
`GarageCars` is highly correlated with `OverallQual` and 6 other fields	High correlation
`GarageArea` is highly correlated with `OverallQual` and 4 other fields	High correlation
`SalePrice` is highly correlated with `OverallQual` and 9 other fields	High correlation
`OverallQual` is highly correlated with `YearBuilt` and 7 other fields	High correlation
`YearBuilt` is highly correlated with `OverallQual` and 3 other fields	High correlation
`BsmtFinSF1` is highly correlated with `TotalBsmtSF`	High correlation
`TotalBsmtSF` is highly correlated with `OverallQual` and 3 other fields	High correlation
`1stFlrSF` is highly correlated with `TotalBsmtSF` and 2 other fields	High correlation
`2ndFlrSF` is highly correlated with `GrLivArea` and 1 other fields	High correlation
`GrLivArea` is highly correlated with `OverallQual` and 5 other fields	High correlation
`FullBath` is highly correlated with `OverallQual` and 3 other fields	High correlation
`TotRmsAbvGrd` is highly correlated with `2ndFlrSF` and 3 other fields	High correlation
`GarageYrBlt` is highly correlated with `OverallQual` and 3 other fields	High correlation
`GarageCars` is highly correlated with `OverallQual` and 4 other fields	High correlation
`GarageArea` is highly correlated with `OverallQual` and 3 other fields	High correlation
`SalePrice` is highly correlated with `OverallQual` and 8 other fields	High correlation
`OverallQual` is highly correlated with `YearBuilt` and 3 other fields	High correlation
`YearBuilt` is highly correlated with `OverallQual` and 1 other fields	High correlation
`TotalBsmtSF` is highly correlated with `1stFlrSF`	High correlation
`1stFlrSF` is highly correlated with `TotalBsmtSF`	High correlation
`2ndFlrSF` is highly correlated with `GrLivArea`	High correlation
`GrLivArea` is highly correlated with `2ndFlrSF` and 3 other fields	High correlation
`FullBath` is highly correlated with `OverallQual` and 2 other fields	High correlation
`TotRmsAbvGrd` is highly correlated with `GrLivArea`	High correlation
`GarageYrBlt` is highly correlated with `YearBuilt` and 1 other fields	High correlation
`GarageCars` is highly correlated with `OverallQual` and 3 other fields	High correlation
`GarageArea` is highly correlated with `GarageCars`	High correlation
`SalePrice` is highly correlated with `OverallQual` and 3 other fields	High correlation
`ExterQual` is highly correlated with `KitchenQual`	High correlation
`KitchenQual` is highly correlated with `ExterQual`	High correlation
`Neighborhood` is highly correlated with `BsmtQual`	High correlation
`BsmtQual` is highly correlated with `Neighborhood`	High correlation
`Neighborhood` is highly correlated with `OverallQual` and 14 other fields	High correlation
`OverallQual` is highly correlated with `Neighborhood` and 15 other fields	High correlation
`YearBuilt` is highly correlated with `Neighborhood` and 14 other fields	High correlation
`MasVnrArea` is highly correlated with `OverallQual` and 3 other fields	High correlation
`ExterQual` is highly correlated with `Neighborhood` and 9 other fields	High correlation
`BsmtQual` is highly correlated with `Neighborhood` and 9 other fields	High correlation
`BsmtFinSF1` is highly correlated with `TotalBsmtSF` and 4 other fields	High correlation
`TotalBsmtSF` is highly correlated with `OverallQual` and 5 other fields	High correlation
`HeatingQC` is highly correlated with `Neighborhood` and 4 other fields	High correlation
`CentralAir` is highly correlated with `YearBuilt` and 2 other fields	High correlation
`1stFlrSF` is highly correlated with `Neighborhood` and 9 other fields	High correlation
`2ndFlrSF` is highly correlated with `Neighborhood` and 7 other fields	High correlation
`GrLivArea` is highly correlated with `Neighborhood` and 12 other fields	High correlation
`FullBath` is highly correlated with `Neighborhood` and 11 other fields	High correlation
`KitchenQual` is highly correlated with `Neighborhood` and 10 other fields	High correlation
`TotRmsAbvGrd` is highly correlated with `OverallQual` and 5 other fields	High correlation
`GarageYrBlt` is highly correlated with `Neighborhood` and 9 other fields	High correlation
`GarageFinish` is highly correlated with `Neighborhood` and 5 other fields	High correlation
`GarageCars` is highly correlated with `Neighborhood` and 7 other fields	High correlation
`GarageArea` is highly correlated with `Neighborhood` and 12 other fields	High correlation
`SalePrice` is highly correlated with `Neighborhood` and 19 other fields	High correlation
`BsmtQual` has 37 (2.5%) missing values	Missing
`GarageYrBlt` has 81 (5.5%) missing values	Missing
`GarageFinish` has 81 (5.5%) missing values	Missing
`MasVnrArea` has 861 (59.0%) zeros	Zeros
`BsmtFinSF1` has 467 (32.0%) zeros	Zeros
`TotalBsmtSF` has 37 (2.5%) zeros	Zeros
`2ndFlrSF` has 829 (56.8%) zeros	Zeros
`GarageCars` has 81 (5.5%) zeros	Zeros
`GarageArea` has 81 (5.5%) zeros	Zeros

Reproduction

Analysis started	2022-04-24 01:13:35.689954
Analysis finished	2022-04-24 01:13:55.364543
Duration	19.67 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

Neighborhood
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	25
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	90.7 KiB

NAmes	225
CollgCr	150
OldTown	113
Edwards	100
Somerst	86
Other values (20)	786

Length

Max length	7
Median length	7
Mean length	6.494520548
Min length	5

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CollgCr
2nd row	Veenker
3rd row	CollgCr
4th row	Crawfor
5th row	NoRidge

Common Values

Value	Count	Frequency (%)
NAmes	225	15.4%
CollgCr	150	10.3%
OldTown	113	7.7%
Edwards	100	6.8%
Somerst	86	5.9%
Gilbert	79	5.4%
NridgHt	77	5.3%
Sawyer	74	5.1%
NWAmes	73	5.0%
SawyerW	59	4.0%
Other values (15)	424	29.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
names	225	15.4%
collgcr	150	10.3%
oldtown	113	7.7%
edwards	100	6.8%
somerst	86	5.9%
gilbert	79	5.4%
nridght	77	5.3%
sawyer	74	5.1%
nwames	73	5.0%
sawyerw	59	4.0%
Other values (15)	424	29.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

OverallQual
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	10
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.099315068

Minimum	1
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.5 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	5
median	6
Q3	7
95-th percentile	8
Maximum	10
Range	9
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.382996547
Coefficient of variation (CV)	0.2267462053
Kurtosis	0.09629277836
Mean	6.099315068
Median Absolute Deviation (MAD)	1
Skewness	0.2169439278
Sum	8905
Variance	1.912679448
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
5	397	27.2%
6	374	25.6%
7	319	21.8%
8	168	11.5%
4	116	7.9%
9	43	2.9%
3	20	1.4%
10	18	1.2%
2	3	0.2%
1	2	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2	0.1%
2	3	0.2%
3	20	1.4%
4	116	7.9%
5	397	27.2%
6	374	25.6%
7	319	21.8%
8	168	11.5%
9	43	2.9%
10	18	1.2%

Value	Count	Frequency (%)
10	18	1.2%
9	43	2.9%
8	168	11.5%
7	319	21.8%
6	374	25.6%
5	397	27.2%
4	116	7.9%
3	20	1.4%
2	3	0.2%
1	2	0.1%

YearBuilt
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	112
Distinct (%)	7.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1971.267808

Minimum	1872
Maximum	2010
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.5 KiB

Quantile statistics

Minimum	1872
5-th percentile	1916
Q1	1954
median	1973
Q3	2000
95-th percentile	2007
Maximum	2010
Range	138
Interquartile range (IQR)	46

Descriptive statistics

Standard deviation	30.20290404
Coefficient of variation (CV)	0.01532156307
Kurtosis	-0.4395519416
Mean	1971.267808
Median Absolute Deviation (MAD)	25
Skewness	-0.6134611725
Sum	2878051
Variance	912.2154126
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2006	67	4.6%
2005	64	4.4%
2004	54	3.7%
2007	49	3.4%
2003	45	3.1%
1976	33	2.3%
1977	32	2.2%
1920	30	2.1%
1959	26	1.8%
1998	25	1.7%
Other values (102)	1035	70.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1872	1	0.1%
1875	1	0.1%
1880	4	0.3%
1882	1	0.1%
1885	2	0.1%
1890	2	0.1%
1892	2	0.1%
1893	1	0.1%
1898	1	0.1%
1900	10	0.7%

Value	Count	Frequency (%)
2010	1	0.1%
2009	18	1.2%
2008	23	1.6%
2007	49	3.4%
2006	67	4.6%
2005	64	4.4%
2004	54	3.7%
2003	45	3.1%
2002	23	1.6%
2001	20	1.4%

MasVnrArea
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	327
Distinct (%)	22.5%
Missing	8
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	103.6852617

Minimum	0
Maximum	1600
Zeros	861
Zeros (%)	59.0%
Negative	0
Negative (%)	0.0%
Memory size	11.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	166
95-th percentile	456
Maximum	1600
Range	1600
Interquartile range (IQR)	166

Descriptive statistics

Standard deviation	181.0662066
Coefficient of variation (CV)	1.746306115
Kurtosis	10.08241732
Mean	103.6852617
Median Absolute Deviation (MAD)	0
Skewness	2.66908421
Sum	150551
Variance	32784.97117
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	861	59.0%
72	8	0.5%
108	8	0.5%
180	8	0.5%
120	7	0.5%
16	7	0.5%
340	6	0.4%
106	6	0.4%
80	6	0.4%
200	6	0.4%
Other values (317)	529	36.2%
(Missing)	8	0.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	861	59.0%
1	2	0.1%
11	1	0.1%
14	1	0.1%
16	7	0.5%
18	2	0.1%
22	1	0.1%
24	1	0.1%
27	1	0.1%
28	1	0.1%

Value	Count	Frequency (%)
1600	1	0.1%
1378	1	0.1%
1170	1	0.1%
1129	1	0.1%
1115	1	0.1%
1047	1	0.1%
1031	1	0.1%
975	1	0.1%
922	1	0.1%
921	1	0.1%

ExterQual
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	84.2 KiB

TA	906
Gd	488
Ex	52
Fa	14

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Gd
2nd row	TA
3rd row	Gd
4th row	TA
5th row	Gd

Common Values

Value	Count	Frequency (%)
TA	906	62.1%
Gd	488	33.4%
Ex	52	3.6%
Fa	14	1.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
ta	906	62.1%
gd	488	33.4%
ex	52	3.6%
fa	14	1.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

BsmtQual
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	4
Distinct (%)	0.3%
Missing	37
Missing (%)	2.5%
Memory size	83.3 KiB

TA	649
Gd	618
Ex	121
Fa	35

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Gd
2nd row	Gd
3rd row	Gd
4th row	TA
5th row	Gd

Common Values

Value	Count	Frequency (%)
TA	649	44.5%
Gd	618	42.3%
Ex	121	8.3%
Fa	35	2.4%
(Missing)	37	2.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
ta	649	45.6%
gd	618	43.4%
ex	121	8.5%
fa	35	2.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

BsmtFinSF1
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	637
Distinct (%)	43.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	443.639726

Minimum	0
Maximum	5644
Zeros	467
Zeros (%)	32.0%
Negative	0
Negative (%)	0.0%
Memory size	11.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	383.5
Q3	712.25
95-th percentile	1274
Maximum	5644
Range	5644
Interquartile range (IQR)	712.25

Descriptive statistics

Standard deviation	456.0980908
Coefficient of variation (CV)	1.028082167
Kurtosis	11.11823629
Mean	443.639726
Median Absolute Deviation (MAD)	383.5
Skewness	1.685503072
Sum	647714
Variance	208025.4685
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	467	32.0%
24	12	0.8%
16	9	0.6%
686	5	0.3%
662	5	0.3%
20	5	0.3%
936	5	0.3%
616	5	0.3%
560	4	0.3%
553	4	0.3%
Other values (627)	939	64.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	467	32.0%
2	1	0.1%
16	9	0.6%
20	5	0.3%
24	12	0.8%
25	1	0.1%
27	1	0.1%
28	3	0.2%
33	1	0.1%
35	1	0.1%

Value	Count	Frequency (%)
5644	1	0.1%
2260	1	0.1%
2188	1	0.1%
2096	1	0.1%
1904	1	0.1%
1880	1	0.1%
1810	1	0.1%
1767	1	0.1%
1721	1	0.1%
1696	1	0.1%

TotalBsmtSF
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	721
Distinct (%)	49.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1057.429452

Minimum	0
Maximum	6110
Zeros	37
Zeros (%)	2.5%
Negative	0
Negative (%)	0.0%
Memory size	11.5 KiB

Quantile statistics

Minimum	0
5-th percentile	519.3
Q1	795.75
median	991.5
Q3	1298.25
95-th percentile	1753
Maximum	6110
Range	6110
Interquartile range (IQR)	502.5

Descriptive statistics

Standard deviation	438.7053245
Coefficient of variation (CV)	0.4148790481
Kurtosis	13.25048328
Mean	1057.429452
Median Absolute Deviation (MAD)	234.5
Skewness	1.524254549
Sum	1543847
Variance	192462.3617
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	37	2.5%
864	35	2.4%
672	17	1.2%
912	15	1.0%
1040	14	1.0%
816	13	0.9%
768	12	0.8%
728	12	0.8%
894	11	0.8%
780	11	0.8%
Other values (711)	1283	87.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	37	2.5%
105	1	0.1%
190	1	0.1%
264	3	0.2%
270	1	0.1%
290	1	0.1%
319	1	0.1%
360	1	0.1%
372	1	0.1%
384	7	0.5%

Value	Count	Frequency (%)
6110	1	0.1%
3206	1	0.1%
3200	1	0.1%
3138	1	0.1%
3094	1	0.1%
2633	1	0.1%
2524	1	0.1%
2444	1	0.1%
2396	1	0.1%
2392	1	0.1%

HeatingQC
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	84.2 KiB

Ex	741
TA	428
Gd	241
Fa	49
Po	1

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	0.1%

Sample

1st row	Ex
2nd row	Ex
3rd row	Ex
4th row	Gd
5th row	Ex

Common Values

Value	Count	Frequency (%)
Ex	741	50.8%
TA	428	29.3%
Gd	241	16.5%
Fa	49	3.4%
Po	1	0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
ex	741	50.8%
ta	428	29.3%
gd	241	16.5%
fa	49	3.4%
po	1	0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

CentralAir
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.6 KiB

True	1365
False	95

Common Values
Chart

Value	Count	Frequency (%)
True	1365	93.5%
False	95	6.5%

1stFlrSF
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	753
Distinct (%)	51.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1162.626712

Minimum	334
Maximum	4692
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.5 KiB

Quantile statistics

Minimum	334
5-th percentile	672.95
Q1	882
median	1087
Q3	1391.25
95-th percentile	1831.25
Maximum	4692
Range	4358
Interquartile range (IQR)	509.25

Descriptive statistics

Standard deviation	386.587738
Coefficient of variation (CV)	0.3325123481
Kurtosis	5.745841482
Mean	1162.626712
Median Absolute Deviation (MAD)	234.5
Skewness	1.376756622
Sum	1697435
Variance	149450.0792
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
864	25	1.7%
1040	16	1.1%
912	14	1.0%
894	12	0.8%
848	12	0.8%
672	11	0.8%
630	9	0.6%
816	9	0.6%
483	7	0.5%
960	7	0.5%
Other values (743)	1338	91.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
334	1	0.1%
372	1	0.1%
438	1	0.1%
480	1	0.1%
483	7	0.5%
495	1	0.1%
520	5	0.3%
525	1	0.1%
526	1	0.1%
536	1	0.1%

Value	Count	Frequency (%)
4692	1	0.1%
3228	1	0.1%
3138	1	0.1%
2898	1	0.1%
2633	1	0.1%
2524	1	0.1%
2515	1	0.1%
2444	1	0.1%
2411	1	0.1%
2402	1	0.1%

2ndFlrSF
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	417
Distinct (%)	28.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	346.9924658

Minimum	0
Maximum	2065
Zeros	829
Zeros (%)	56.8%
Negative	0
Negative (%)	0.0%
Memory size	11.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	728
95-th percentile	1141.05
Maximum	2065
Range	2065
Interquartile range (IQR)	728

Descriptive statistics

Standard deviation	436.5284359
Coefficient of variation (CV)	1.258034335
Kurtosis	-0.5534635576
Mean	346.9924658
Median Absolute Deviation (MAD)	0
Skewness	0.8130298163
Sum	506609
Variance	190557.0753
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	829	56.8%
728	10	0.7%
504	9	0.6%
546	8	0.5%
672	8	0.5%
600	7	0.5%
720	7	0.5%
896	6	0.4%
862	5	0.3%
780	5	0.3%
Other values (407)	566	38.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	829	56.8%
110	1	0.1%
167	1	0.1%
192	1	0.1%
208	1	0.1%
213	1	0.1%
220	1	0.1%
224	1	0.1%
240	2	0.1%
252	2	0.1%

Value	Count	Frequency (%)
2065	1	0.1%
1872	1	0.1%
1818	1	0.1%
1796	1	0.1%
1611	1	0.1%
1589	1	0.1%
1540	1	0.1%
1538	1	0.1%
1523	1	0.1%
1519	1	0.1%

GrLivArea
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	861
Distinct (%)	59.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1515.463699

Minimum	334
Maximum	5642
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.5 KiB

Quantile statistics

Minimum	334
5-th percentile	848
Q1	1129.5
median	1464
Q3	1776.75
95-th percentile	2466.1
Maximum	5642
Range	5308
Interquartile range (IQR)	647.25

Descriptive statistics

Standard deviation	525.4803834
Coefficient of variation (CV)	0.3467456092
Kurtosis	4.895120581
Mean	1515.463699
Median Absolute Deviation (MAD)	326
Skewness	1.366560356
Sum	2212577
Variance	276129.6334
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
864	22	1.5%
1040	14	1.0%
894	11	0.8%
1456	10	0.7%
848	10	0.7%
1200	9	0.6%
912	9	0.6%
816	8	0.5%
1092	8	0.5%
1728	7	0.5%
Other values (851)	1352	92.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
334	1	0.1%
438	1	0.1%
480	1	0.1%
520	1	0.1%
605	1	0.1%
616	1	0.1%
630	6	0.4%
672	2	0.1%
691	1	0.1%
693	1	0.1%

Value	Count	Frequency (%)
5642	1	0.1%
4676	1	0.1%
4476	1	0.1%
4316	1	0.1%
3627	1	0.1%
3608	1	0.1%
3493	1	0.1%
3447	1	0.1%
3395	1	0.1%
3279	1	0.1%

FullBath
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.565068493

Minimum	0
Maximum	3
Zeros	9
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	11.5 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	2
95-th percentile	2
Maximum	3
Range	3
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.5509158013
Coefficient of variation (CV)	0.3520074704
Kurtosis	-0.8570428213
Mean	1.565068493
Median Absolute Deviation (MAD)	0
Skewness	0.0365615584
Sum	2285
Variance	0.3035082201
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=4)

Value	Count	Frequency (%)
2	768	52.6%
1	650	44.5%
3	33	2.3%
0	9	0.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	9	0.6%
1	650	44.5%
2	768	52.6%
3	33	2.3%

Value	Count	Frequency (%)
3	33	2.3%
2	768	52.6%
1	650	44.5%
0	9	0.6%

KitchenQual
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	84.2 KiB

TA	735
Gd	586
Ex	100
Fa	39

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Gd
2nd row	TA
3rd row	Gd
4th row	Gd
5th row	Gd

Common Values

Value	Count	Frequency (%)
TA	735	50.3%
Gd	586	40.1%
Ex	100	6.8%
Fa	39	2.7%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
ta	735	50.3%
gd	586	40.1%
ex	100	6.8%
fa	39	2.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

TotRmsAbvGrd
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.517808219

Minimum	2
Maximum	14
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.5 KiB

Quantile statistics

Minimum	2
5-th percentile	4
Q1	5
median	6
Q3	7
95-th percentile	10
Maximum	14
Range	12
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.625393291
Coefficient of variation (CV)	0.2493772808
Kurtosis	0.8807615657
Mean	6.517808219
Median Absolute Deviation (MAD)	1
Skewness	0.6763408364
Sum	9516
Variance	2.641903349
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
6	402	27.5%
7	329	22.5%
5	275	18.8%
8	187	12.8%
4	97	6.6%
9	75	5.1%
10	47	3.2%
11	18	1.2%
3	17	1.2%
12	11	0.8%
Other values (2)	2	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	1	0.1%
3	17	1.2%
4	97	6.6%
5	275	18.8%
6	402	27.5%
7	329	22.5%
8	187	12.8%
9	75	5.1%
10	47	3.2%
11	18	1.2%

Value	Count	Frequency (%)
14	1	0.1%
12	11	0.8%
11	18	1.2%
10	47	3.2%
9	75	5.1%
8	187	12.8%
7	329	22.5%
6	402	27.5%
5	275	18.8%
4	97	6.6%

GarageYrBlt
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	97
Distinct (%)	7.0%
Missing	81
Missing (%)	5.5%
Infinite	0
Infinite (%)	0.0%
Mean	1978.506164

Minimum	1900
Maximum	2010
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.5 KiB

Quantile statistics

Minimum	1900
5-th percentile	1930
Q1	1961
median	1980
Q3	2002
95-th percentile	2007
Maximum	2010
Range	110
Interquartile range (IQR)	41

Descriptive statistics

Standard deviation	24.68972477
Coefficient of variation (CV)	0.01247897288
Kurtosis	-0.418340998
Mean	1978.506164
Median Absolute Deviation (MAD)	21
Skewness	-0.6494146239
Sum	2728360
Variance	609.5825091
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2005	65	4.5%
2006	59	4.0%
2004	53	3.6%
2003	50	3.4%
2007	49	3.4%
1977	35	2.4%
1998	31	2.1%
1999	30	2.1%
1976	29	2.0%
2008	29	2.0%
Other values (87)	949	65.0%
(Missing)	81	5.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1900	1	0.1%
1906	1	0.1%
1908	1	0.1%
1910	3	0.2%
1914	2	0.1%
1915	2	0.1%
1916	5	0.3%
1918	2	0.1%
1920	14	1.0%
1921	3	0.2%

Value	Count	Frequency (%)
2010	3	0.2%
2009	21	1.4%
2008	29	2.0%
2007	49	3.4%
2006	59	4.0%
2005	65	4.5%
2004	53	3.6%
2003	50	3.4%
2002	26	1.8%
2001	20	1.4%

GarageFinish
Categorical

HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	0.2%
Missing	81
Missing (%)	5.5%
Memory size	83.5 KiB

Unf	605
RFn	422
Fin	352

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RFn
2nd row	RFn
3rd row	RFn
4th row	Unf
5th row	RFn

Common Values

Value	Count	Frequency (%)
Unf	605	41.4%
RFn	422	28.9%
Fin	352	24.1%
(Missing)	81	5.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
unf	605	43.9%
rfn	422	30.6%
fin	352	25.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

GarageCars
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	5
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.767123288

Minimum	0
Maximum	4
Zeros	81
Zeros (%)	5.5%
Negative	0
Negative (%)	0.0%
Memory size	11.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	2
95-th percentile	3
Maximum	4
Range	4
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.7473150101
Coefficient of variation (CV)	0.4228991918
Kurtosis	0.220997764
Mean	1.767123288
Median Absolute Deviation (MAD)	0
Skewness	-0.3425489297
Sum	2580
Variance	0.5584797243
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=5)

Value	Count	Frequency (%)
2	824	56.4%
1	369	25.3%
3	181	12.4%
0	81	5.5%
4	5	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	81	5.5%
1	369	25.3%
2	824	56.4%
3	181	12.4%
4	5	0.3%

Value	Count	Frequency (%)
4	5	0.3%
3	181	12.4%
2	824	56.4%
1	369	25.3%
0	81	5.5%

GarageArea
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	441
Distinct (%)	30.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	472.980137

Minimum	0
Maximum	1418
Zeros	81
Zeros (%)	5.5%
Negative	0
Negative (%)	0.0%
Memory size	11.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	334.5
median	480
Q3	576
95-th percentile	850.1
Maximum	1418
Range	1418
Interquartile range (IQR)	241.5

Descriptive statistics

Standard deviation	213.8048415
Coefficient of variation (CV)	0.452037675
Kurtosis	0.9170672023
Mean	472.980137
Median Absolute Deviation (MAD)	120
Skewness	0.1799809067
Sum	690551
Variance	45712.51023
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	81	5.5%
440	49	3.4%
576	47	3.2%
240	38	2.6%
484	34	2.3%
528	33	2.3%
288	27	1.8%
400	25	1.7%
264	24	1.6%
480	24	1.6%
Other values (431)	1078	73.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	81	5.5%
160	2	0.1%
164	1	0.1%
180	9	0.6%
186	1	0.1%
189	1	0.1%
192	1	0.1%
198	1	0.1%
200	4	0.3%
205	3	0.2%

Value	Count	Frequency (%)
1418	1	0.1%
1390	1	0.1%
1356	1	0.1%
1248	1	0.1%
1220	1	0.1%
1166	1	0.1%
1134	1	0.1%
1069	1	0.1%
1053	1	0.1%
1052	2	0.1%

SalePrice
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	663
Distinct (%)	45.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	180921.1959

Minimum	34900
Maximum	755000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.5 KiB

Quantile statistics

Minimum	34900
5-th percentile	88000
Q1	129975
median	163000
Q3	214000
95-th percentile	326100
Maximum	755000
Range	720100
Interquartile range (IQR)	84025

Descriptive statistics

Standard deviation	79442.50288
Coefficient of variation (CV)	0.4391000319
Kurtosis	6.53628186
Mean	180921.1959
Median Absolute Deviation (MAD)	38000
Skewness	1.88287576
Sum	264144946
Variance	6311111264
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
140000	20	1.4%
135000	17	1.2%
155000	14	1.0%
145000	14	1.0%
190000	13	0.9%
110000	13	0.9%
115000	12	0.8%
160000	12	0.8%
130000	11	0.8%
139000	11	0.8%
Other values (653)	1323	90.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
34900	1	0.1%
35311	1	0.1%
37900	1	0.1%
39300	1	0.1%
40000	1	0.1%
52000	1	0.1%
52500	1	0.1%
55000	2	0.1%
55993	1	0.1%
58500	1	0.1%

Value	Count	Frequency (%)
755000	1	0.1%
745000	1	0.1%
625000	1	0.1%
611657	1	0.1%
582933	1	0.1%
556581	1	0.1%
555000	1	0.1%
538000	1	0.1%
501837	1	0.1%
485000	1	0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Neighborhood	OverallQual	YearBuilt	MasVnrArea	ExterQual	BsmtQual	BsmtFinSF1	TotalBsmtSF	HeatingQC	CentralAir	1stFlrSF	2ndFlrSF	GrLivArea	FullBath	KitchenQual	TotRmsAbvGrd	GarageYrBlt	GarageFinish	GarageCars	GarageArea	SalePrice
0	CollgCr	7	2003	196.0	Gd	Gd	706	856	Ex	Y	856	854	1710	2	Gd	8	2003.0	RFn	2	548	208500
1	Veenker	6	1976	0.0	TA	Gd	978	1262	Ex	Y	1262	0	1262	2	TA	6	1976.0	RFn	2	460	181500
2	CollgCr	7	2001	162.0	Gd	Gd	486	920	Ex	Y	920	866	1786	2	Gd	6	2001.0	RFn	2	608	223500
3	Crawfor	7	1915	0.0	TA	TA	216	756	Gd	Y	961	756	1717	1	Gd	7	1998.0	Unf	3	642	140000
4	NoRidge	8	2000	350.0	Gd	Gd	655	1145	Ex	Y	1145	1053	2198	2	Gd	9	2000.0	RFn	3	836	250000
5	Mitchel	5	1993	0.0	TA	Gd	732	796	Ex	Y	796	566	1362	1	TA	5	1993.0	Unf	2	480	143000
6	Somerst	8	2004	186.0	Gd	Ex	1369	1686	Ex	Y	1694	0	1694	2	Gd	7	2004.0	RFn	2	636	307000
7	NWAmes	7	1973	240.0	TA	Gd	859	1107	Ex	Y	1107	983	2090	2	TA	7	1973.0	RFn	2	484	200000
8	OldTown	7	1931	0.0	TA	TA	0	952	Gd	Y	1022	752	1774	2	TA	8	1931.0	Unf	2	468	129900
9	BrkSide	5	1939	0.0	TA	TA	851	991	Ex	Y	1077	0	1077	1	TA	5	1939.0	RFn	1	205	118000

Last rows

	Neighborhood	OverallQual	YearBuilt	MasVnrArea	ExterQual	BsmtQual	BsmtFinSF1	TotalBsmtSF	HeatingQC	CentralAir	1stFlrSF	2ndFlrSF	GrLivArea	FullBath	KitchenQual	TotRmsAbvGrd	GarageYrBlt	GarageFinish	GarageCars	GarageArea	SalePrice
1450	NAmes	5	1974	0.0	TA	Gd	0	896	TA	Y	896	896	1792	2	TA	8	NaN	None	0	0	136000
1451	Somerst	8	2008	194.0	Gd	Gd	0	1573	Ex	Y	1578	0	1578	2	Ex	7	2008.0	Fin	3	840	287090
1452	Edwards	5	2005	80.0	TA	Gd	547	547	Gd	Y	1072	0	1072	1	TA	5	2005.0	Fin	2	525	145000
1453	Mitchel	5	2006	0.0	TA	Gd	0	1140	Ex	Y	1140	0	1140	1	TA	6	NaN	None	0	0	84500
1454	Somerst	7	2004	0.0	Gd	Gd	410	1221	Ex	Y	1221	0	1221	2	Gd	6	2004.0	RFn	2	400	185000
1455	Gilbert	6	1999	0.0	TA	Gd	0	953	Ex	Y	953	694	1647	2	TA	7	1999.0	RFn	2	460	175000
1456	NWAmes	6	1978	119.0	TA	Gd	790	1542	TA	Y	2073	0	2073	2	TA	7	1978.0	Unf	2	500	210000
1457	Crawfor	7	1941	0.0	Ex	TA	275	1152	Ex	Y	1188	1152	2340	2	Gd	9	1941.0	RFn	1	252	266500
1458	NAmes	5	1950	0.0	TA	TA	49	1078	Gd	Y	1078	0	1078	1	Gd	5	1950.0	Unf	1	240	142125
1459	Edwards	5	1965	0.0	Gd	TA	830	1256	Gd	Y	1256	0	1256	1	TA	6	1965.0	Fin	1	276	147500

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows